UPDATE EMPLOYEE SET EmpPhone = '070123412' WHERE EmployeeID=1;

UPDATE RECIPES SET EmployeeID=null WHERE EmployeeID=5;
DELETE EMPLOYEE WHERE EmployeeID=5;

UPDATE Title SET TITLE='Master Disher' WHERE TITLE='Disher';
DELETE FROM TITLE WHERE TITLE='Master Disher';

UPDATE IngredientTypes SET IngredientType='Fruity fruit' WHERE IngredientType='Fruit';
DELETE FROM IngredientTypes WHERE IngredientType LIKE '%fruit%';

UPDATE Ingredients SET IngredientName='Cheese' WHERE IngredientName LIKE '%Os%';
DELETE FROM Ingredients WHERE IngredientID='16';


UPDATE Units SET unit='kilog' where unit LIKE '%ilogr%';
DELETE FROM Units WHERE unit='kilog';

UPDATE RecipeTypes SET RecipeType='Not a test anymore', description='OK' WHERE image='recipetype/hej.jpg';
DELETE FROM RecipeTypes WHERE RecipeType='Not a test anymore';

UPDATE Recipes SET EmployeeID=4 WHERE EmployeeID IS NULL;
DELETE Recipes WHERE RecipeID=9;

UPDATE Steps SET Instruction='Buy pizza' WHERE StepNumber=4;
DELETE FROM STEPS WHERE StepNumber=6;

INSERT StepIngredient(StepNo, RecipeID, IngredientID, amount, unit) VALUES (11,3,6,1, 'bunch');

UPDATE StepIngredient SET unit='st' WHERE StepNo = 11;
DELETE FROM StepIngredient WHERE StepNo  = 11;

UPDATE MenuTypes SET description='Nice beef menu with a grill' WHERE MenuType='BBQ';
DELETE FROM MenuTypes WHERE MenuType LIKE '%nice%';

UPDATE Menus SET EmployeeID=1 WHERE EmployeeID IS NULL;
DELETE FROM Menus WHERE MenuID=7;

UPDATE MenuRecipe SET RecipeID=5 WHERE RecipeID=7;
DELETE FROM MenuRecipe WHERE RecipeID <= 1;